﻿# C
snippet char
	CHAR(${1})${2}
snippet commentt
	comment on table ${1:user}.${2:table} is '${3}';${4}
snippet commentc
	comment on column ${1:user}.${2:table}.${3:column} is '${4}';${5}
snippet createt 
	CREATE TABLE ${1:user}.${2:TabName}
	(
		id number PRIMARY KEY,
		${3}
	);
snippet sequence
	CREATE SEQUENCE ${1:user}.seq_${2:table}
	start with 1
	increment by 1;
# T
snippet tablespace
	tablespace busidata
		pctfree 10
		initrans 1
		maxtrans 255
		storage
		(
			initial 64K
			next 1M
			minextents 1
			maxextents unlimited
		);
# V
snippet var
	VARCHAR2(${1})${2}
# N
snippet not
	not null
